/*
MySQL Backup
Database: inspection_db
Backup Time: 2025-09-25 22:04:01
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `inspection_db`.`according`;
DROP TABLE IF EXISTS `inspection_db`.`client_apps`;
DROP TABLE IF EXISTS `inspection_db`.`data_cast_in_situ_structure`;
DROP TABLE IF EXISTS `inspection_db`.`data_concrete_construction`;
DROP TABLE IF EXISTS `inspection_db`.`data_concrete_mix`;
DROP TABLE IF EXISTS `inspection_db`.`data_formwork_installation`;
DROP TABLE IF EXISTS `inspection_db`.`data_rebar_connect`;
DROP TABLE IF EXISTS `inspection_db`.`data_rebar_installation`;
DROP TABLE IF EXISTS `inspection_db`.`data_rebar_material`;
DROP TABLE IF EXISTS `inspection_db`.`data_rebar_process`;
DROP TABLE IF EXISTS `inspection_db`.`detail_inspection_original`;
DROP TABLE IF EXISTS `inspection_db`.`idempotent_requests`;
DROP TABLE IF EXISTS `inspection_db`.`projects`;
DROP TABLE IF EXISTS `inspection_db`.`rebar_inspection_record`;
DROP TABLE IF EXISTS `inspection_db`.`rmc_construction_record`;
DROP TABLE IF EXISTS `inspection_db`.`standard_cast_in_situ_structure`;
DROP TABLE IF EXISTS `inspection_db`.`standard_concrete_construction`;
DROP TABLE IF EXISTS `inspection_db`.`standard_concrete_mix`;
DROP TABLE IF EXISTS `inspection_db`.`standard_formwork_installation`;
DROP TABLE IF EXISTS `inspection_db`.`standard_rebar_connect`;
DROP TABLE IF EXISTS `inspection_db`.`standard_rebar_installation`;
DROP TABLE IF EXISTS `inspection_db`.`standard_rebar_material`;
DROP TABLE IF EXISTS `inspection_db`.`standard_rebar_process`;
DROP TABLE IF EXISTS `inspection_db`.`task_type_item`;
DROP TABLE IF EXISTS `inspection_db`.`tasks`;
DROP TABLE IF EXISTS `inspection_db`.`user_project`;
DROP TABLE IF EXISTS `inspection_db`.`user_task_inspection`;
DROP TABLE IF EXISTS `inspection_db`.`users`;
CREATE TABLE `according` (
  `task_id` bigint NOT NULL,
  `manufacture_according` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '施工依据',
  `acceptance_according` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '验收依据',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `client_apps` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `client_id` varchar(64) NOT NULL,
  `client_secret` varchar(255) NOT NULL,
  `hmac_secret` varchar(255) DEFAULT NULL,
  `scopes` varchar(512) DEFAULT 'users:sync projects:sync tasks:sync push:send',
  `rate_limit_per_min` int DEFAULT '600',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `client_id` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `data_cast_in_situ_structure` (
  `task_id` bigint NOT NULL,
  `appearance_severe_defects_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-严重缺陷-实际抽样数量',
  `appearance_severe_defects_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '外观质量-严重缺陷-检查记录',
  `appearance_severe_defects_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-严重缺陷-检查结果',
  `appearance_severe_defects_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '外观质量-严重缺陷-照片',
  `appearance_functional_deviation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-结构性能尺寸偏差-实际抽样数量',
  `appearance_functional_deviation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '外观质量-结构性能尺寸偏差-检查记录',
  `appearance_functional_deviation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-结构性能尺寸偏差-检查结果',
  `appearance_general_defects_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-一般缺陷-实际抽样数量',
  `appearance_general_defects_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '外观质量-一般缺陷-检查记录',
  `appearance_general_defects_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-一般缺陷-检查结果',
  `axis_position_overall_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-整体基础-实际抽样数量',
  `axis_position_overall_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '轴线位置-整体基础-检查记录',
  `axis_position_overall_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-整体基础-检查结果',
  `axis_position_independent_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-独立基础-实际抽样数量',
  `axis_position_independent_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '轴线位置-独立基础-检查记录',
  `axis_position_independent_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-独立基础-检查结果',
  `axis_position_column_wall_beam_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-柱墙梁-实际抽样数量',
  `axis_position_column_wall_beam_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '轴线位置-柱墙梁-检查记录',
  `axis_position_column_wall_beam_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-柱墙梁-检查结果',
  `verticality_floor_height_under_6m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高≤6m-实际抽样数量',
  `verticality_floor_height_under_6m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '垂直度-层高≤6m-检查记录',
  `verticality_floor_height_under_6m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高≤6m-检查结果',
  `verticality_floor_height_over_6m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高＞6m-实际抽样数量',
  `verticality_floor_height_over_6m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '垂直度-层高＞6m-检查记录',
  `verticality_floor_height_over_6m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高＞6m-检查结果',
  `verticality_total_height_under_300m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＜300m-实际抽样数量',
  `verticality_total_height_under_300m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '垂直度-全高＜300m-检查记录',
  `verticality_total_height_under_300m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＜300m-检查结果',
  `verticality_total_height_over_300m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＞300m-实际抽样数量',
  `verticality_total_height_over_300m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '垂直度-全高＞300m-检查记录',
  `verticality_total_height_over_300m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＞300m-检查结果',
  `elevation_floor_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-层高-实际抽样数量',
  `elevation_floor_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '标高-层高-检查记录',
  `elevation_floor_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-层高-检查结果',
  `elevation_total_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-全高-实际抽样数量',
  `elevation_total_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '标高-全高-检查记录',
  `elevation_total_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-全高-检查结果',
  `section_dimension_foundation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-基础-实际抽样数量',
  `section_dimension_foundation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '截面尺寸-基础-检查记录',
  `section_dimension_foundation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-基础-检查结果',
  `section_dimension_cwsb_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-柱梁板墙-实际抽样数量',
  `section_dimension_cwsb_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '截面尺寸-柱梁板墙-检查记录',
  `section_dimension_cwsb_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-柱梁板墙-检查结果',
  `section_dimension_stairs_step_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-楼梯踏步高差-实际抽样数量',
  `section_dimension_stairs_step_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '截面尺寸-楼梯踏步高差-检查记录',
  `section_dimension_stairs_step_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-楼梯踏步高差-检查结果',
  `elevator_shaft_center_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-中心位置-实际抽样数量',
  `elevator_shaft_center_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '电梯井-中心位置-检查记录',
  `elevator_shaft_center_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-中心位置-检查结果',
  `elevator_shaft_dimensions_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-长宽尺寸-实际抽样数量',
  `elevator_shaft_dimensions_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '电梯井-长宽尺寸-检查记录',
  `elevator_shaft_dimensions_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-长宽尺寸-检查结果',
  `surface_flatness_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表面平整度-实际抽样数量',
  `surface_flatness_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '表面平整度-检查记录',
  `surface_flatness_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表面平整度-检查结果',
  `embedded_part_plate_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋板-实际抽样数量',
  `embedded_part_plate_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-预埋板-检查记录',
  `embedded_part_plate_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋板-检查结果',
  `embedded_part_bolt_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋螺栓-实际抽样数量',
  `embedded_part_bolt_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-预埋螺栓-检查记录',
  `embedded_part_bolt_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋螺栓-检查结果',
  `embedded_part_pipe_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋管-实际抽样数量',
  `embedded_part_pipe_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-预埋管-检查记录',
  `embedded_part_pipe_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋管-检查结果',
  `embedded_part_other_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-其他-实际抽样数量',
  `embedded_part_other_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-其他-检查记录',
  `embedded_part_other_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-其他-检查结果',
  `reserved_opening_centerline_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预留洞孔中心线位置-实际抽样数量',
  `reserved_opening_centerline_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预留洞孔中心线位置-检查记录',
  `reserved_opening_centerline_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预留洞孔中心线位置-检查结果',
  `reserved_opening_centerline_position_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预留洞孔中心线位置-照片',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='现浇结构数据记录表';
CREATE TABLE `data_concrete_construction` (
  `task_id` bigint NOT NULL,
  `post_pour_strip_joint_method_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后浇带和施工缝-实际抽样数量',
  `post_pour_strip_joint_method_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '后浇带和施工缝-检查记录',
  `post_pour_strip_joint_method_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后浇带和施工缝-检查结果',
  `post_pour_strip_joint_method_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '后浇带和施工缝-照片',
  `post_pour_curing_measures_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浇筑后养护措施-实际抽样数量',
  `post_pour_curing_measures_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '浇筑后养护措施-检查记录',
  `post_pour_curing_measures_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浇筑后养护措施-检查结果',
  `post_pour_curing_measures_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '浇筑后养护措施-照片',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='混凝土施工数据记录表';
CREATE TABLE `data_concrete_mix` (
  `task_id` bigint NOT NULL,
  `ready_mixed_concrete_quality_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预拌混凝土质量-实际抽样数量',
  `ready_mixed_concrete_quality_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预拌混凝土质量-检查记录',
  `ready_mixed_concrete_quality_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预拌混凝土质量-检查结果',
  `ready_mixed_concrete_quality_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预拌混凝土质量-扫描件(配合比通知单等)',
  `concrete_mix_segregation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土拌合物不应离析-实际抽样数量',
  `concrete_mix_segregation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '混凝土拌合物不应离析-检查记录',
  `concrete_mix_segregation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土拌合物不应离析-检查结果',
  `chloride_alkali_content_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氯离子含量和碱总量-实际抽样数量',
  `chloride_alkali_content_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '氯离子含量和碱总量-检查记录',
  `chloride_alkali_content_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '氯离子含量和碱总量-检查结果',
  `chloride_alkali_content_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '氯离子含量和碱总量-扫描件(质量证明文件)',
  `first_use_mix_ratio_appraisal_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首次使用配合比开盘鉴定-实际抽样数量',
  `first_use_mix_ratio_appraisal_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '首次使用配合比开盘鉴定-检查记录',
  `first_use_mix_ratio_appraisal_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首次使用配合比开盘鉴定-检查结果',
  `first_use_mix_ratio_appraisal_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '首次使用配合比开盘鉴定-扫描件(质量证明文件)',
  `concrete_mix_consistency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土拌合物稠度-实际抽样数量',
  `concrete_mix_consistency_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '混凝土拌合物稠度-检查记录',
  `concrete_mix_consistency_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土拌合物稠度-检查结果',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='混凝土拌合物数据记录表';
CREATE TABLE `data_formwork_installation` (
  `task_id` bigint NOT NULL,
  `material_appearance_spec_size_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '材料外观规格尺寸-实际抽样数量',
  `material_appearance_spec_size_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '材料外观规格尺寸-检查记录',
  `material_appearance_spec_size_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '材料外观规格尺寸-检查结果',
  `material_appearance_spec_size_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '材料外观规格尺寸-照片',
  `material_appearance_spec_size_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '材料外观规格尺寸-PDF',
  `installation_quality_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板及支架安装质量-实际抽样数量',
  `installation_quality_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板及支架安装质量-检查记录',
  `installation_quality_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板及支架安装质量-检查结果',
  `post_poured_strip_setup_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后浇带处模板支架设置-实际抽样数量',
  `post_poured_strip_setup_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '后浇带处模板支架设置-检查记录',
  `post_poured_strip_setup_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '后浇带处模板支架设置-检查结果',
  `support_post_on_soil_requirements_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支架竖杆土层要求-实际抽样数量',
  `support_post_on_soil_requirements_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '支架竖杆土层要求-检查记录',
  `support_post_on_soil_requirements_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支架竖杆土层要求-检查结果',
  `formwork_seam_tightness_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板安装质量要求-实际抽样数量',
  `formwork_seam_tightness_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板安装质量要求-检查记录',
  `formwork_seam_tightness_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板安装质量要求-检查结果',
  `release_agent_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '隔离剂-实际抽样数量',
  `release_agent_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '隔离剂-检查记录',
  `release_agent_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '隔离剂-检查结果',
  `camber_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板起拱高度-实际抽样数量',
  `camber_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板起拱高度-检查记录',
  `camber_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板起拱高度-检查结果',
  `multi_story_shoring_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '多层连续支模-实际抽样数量',
  `multi_story_shoring_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '多层连续支模-检查记录',
  `multi_story_shoring_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '多层连续支模-检查结果',
  `fixed_embedded_parts_openings_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '固定预埋件预留孔洞-实际抽样数量',
  `fixed_embedded_parts_openings_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '固定预埋件预留孔洞-检查记录',
  `fixed_embedded_parts_openings_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '固定预埋件预留孔洞-检查结果',
  `deviation_embedded_centerline_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋中心线-实际抽样数量',
  `deviation_embedded_centerline_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预埋中心线-检查记录',
  `deviation_embedded_centerline_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋中心线-检查结果',
  `deviation_embedded_pipe_hole_centerline_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋管中心线-实际抽样数量',
  `deviation_embedded_pipe_hole_centerline_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预埋管孔中心线-检查记录',
  `deviation_embedded_pipe_hole_centerline_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋管孔中心线-检查结果',
  `deviation_rebar_insert_centerline_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋中心线-实际抽样数量',
  `deviation_rebar_insert_centerline_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-插筋中心线-检查记录',
  `deviation_rebar_insert_centerline_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋中心线-检查结果',
  `deviation_rebar_insert_exposed_length_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋外露长度-实际抽样数量',
  `deviation_rebar_insert_exposed_length_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-插筋外露长度-检查记录',
  `deviation_rebar_insert_exposed_length_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋外露长度-检查结果',
  `deviation_embedded_bolt_centerline_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓中心线-实际抽样数量',
  `deviation_embedded_bolt_centerline_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预埋螺栓中心线-检查记录',
  `deviation_embedded_bolt_centerline_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓中心线-检查结果',
  `deviation_embedded_bolt_exposed_length_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓外露长度-实际抽样数量',
  `deviation_embedded_bolt_exposed_length_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预埋螺栓外露长度-检查记录',
  `deviation_embedded_bolt_exposed_length_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓外露长度-检查结果',
  `deviation_reserved_opening_centerline_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞中心线-实际抽样数量',
  `deviation_reserved_opening_centerline_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预留洞中心线-检查记录',
  `deviation_reserved_opening_centerline_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞中心线-检查结果',
  `deviation_reserved_opening_dimensions_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞尺寸-实际抽样数量',
  `deviation_reserved_opening_dimensions_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '偏差-预留洞尺寸-检查记录',
  `deviation_reserved_opening_dimensions_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞尺寸-检查结果',
  `formwork_deviation_axis_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-轴线位置-实际抽样数量',
  `formwork_deviation_axis_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-轴线位置-检查记录',
  `formwork_deviation_axis_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-轴线位置-检查结果',
  `formwork_deviation_bottom_elevation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-底模上表面标高-实际抽样数量',
  `formwork_deviation_bottom_elevation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-底模上表面标高-检查记录',
  `formwork_deviation_bottom_elevation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-底模上表面标高-检查结果',
  `formwork_deviation_internal_basic_dimensions_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸(基础)-实际抽样数量',
  `formwork_deviation_internal_basic_dimensions_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-内部尺寸(基础)-检查记录',
  `formwork_deviation_internal_basic_dimensions_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸(基础)-检查结果',
  `formwork_deviation_internal_dimensions_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸(柱墙梁)-实际抽样数量',
  `formwork_deviation_internal_dimensions_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-内部尺寸(柱墙梁)-检查记录',
  `formwork_deviation_internal_dimensions_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸(柱墙梁)-检查结果',
  `formwork_deviation_stairs_step_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-楼梯相邻踏步高差-实际抽样数量',
  `formwork_deviation_stairs_step_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-楼梯相邻踏步高差-检查记录',
  `formwork_deviation_stairs_step_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-楼梯相邻踏步高差-检查结果',
  `formwork_deviation_verticality_under_6m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(层高小于6m)-实际抽양数量',
  `formwork_deviation_verticality_under_6m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-垂直度(层高小于6m)-检查记录',
  `formwork_deviation_verticality_under_6m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(层高小于6m)-检查结果',
  `formwork_deviation_verticality_over_6m_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(层高大于6m)-实际抽样数量',
  `formwork_deviation_verticality_over_6m_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-垂直度(层高大于6m)-检查记录',
  `formwork_deviation_verticality_over_6m_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(层高大于6m)-检查结果',
  `formwork_deviation_adjacent_surface_diff_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-相邻表面高低差-实际抽样数量',
  `formwork_deviation_adjacent_surface_diff_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-相邻表面高低差-检查记录',
  `formwork_deviation_adjacent_surface_diff_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-相邻表面高低差-检查结果',
  `formwork_deviation_surface_flatness_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-表面平整度-实际抽样数量',
  `formwork_deviation_surface_flatness_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '模板偏差-表面平整度-检查记录',
  `formwork_deviation_surface_flatness_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-表面平整度-检查结果',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='模板安装数据记录表(修正完整版)';
CREATE TABLE `data_rebar_connect` (
  `task_id` bigint NOT NULL,
  `rebar_connection_method_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋的连接方式-实际抽样数量',
  `rebar_connection_method_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '钢筋的连接方式-检查记录',
  `rebar_connection_method_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋的连接方式-检查结果',
  `torque_and_diameter_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '扭矩值与压痕直径-实际抽样数量',
  `torque_and_diameter_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '扭矩值与压痕直径-检查记录',
  `torque_and_diameter_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '扭矩值与压痕直径-检查结果',
  `coupler_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋接头的位置-实际抽样数量',
  `coupler_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '钢筋接头的位置-检查记录',
  `coupler_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋接头的位置-检查结果',
  `coupler_appearance_quality_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接头外观质量-实际抽样数量',
  `coupler_appearance_quality_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '接头外观质量-检查记录',
  `coupler_appearance_quality_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接头外观质量-检查结果',
  `coupler_appearance_quality_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '接头外观质量-照片',
  `coupler_area_percentage_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接头面积百分率-实际抽样数量',
  `coupler_area_percentage_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '接头面积百分率-检查记录',
  `coupler_area_percentage_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接头面积百分率-检查结果',
  `lap_splice_setting_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎搭接接头设置-实际抽样数量',
  `lap_splice_setting_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎搭接接头设置-检查记录',
  `lap_splice_setting_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎搭接接头设置-检查结果',
  `lap_splice_setting_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎搭接接头设置-照片',
  `stirrup_setting_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '搭接长度内箍筋设置-实际抽样数量',
  `stirrup_setting_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '搭接长度内箍筋设置-检查记录',
  `stirrup_setting_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '搭接长度内箍筋设置-检查结果',
  `stirrup_setting_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '搭接长度内箍筋设置-照片',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋连接数据记录表';
CREATE TABLE `data_rebar_installation` (
  `task_id` bigint NOT NULL,
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  `rebar_grade_spec_quantity_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '受力钢筋牌号规格数量-实际抽样数量',
  `rebar_grade_spec_quantity_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '受力钢筋牌号规格数量-检查记录',
  `rebar_grade_spec_quantity_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '受力钢筋牌号规格数量-检查结果',
  `rebar_installation_anchoring_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '受力钢筋安装位置锚固-实际抽样数量',
  `rebar_installation_anchoring_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '受力钢筋安装位置锚固-检查记录',
  `rebar_installation_anchoring_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '受力钢筋安装位置锚固-检查结果',
  `tie_rebar_mesh_dimensions_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋网-长宽-实际抽样数量',
  `tie_rebar_mesh_dimensions_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎钢筋网-长宽-检查记录',
  `tie_rebar_mesh_dimensions_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋网-长宽-检查结果',
  `tie_rebar_mesh_size_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋网-网眼尺寸-实际抽样数量',
  `tie_rebar_mesh_size_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎钢筋网-网眼尺寸-检查记录',
  `tie_rebar_mesh_size_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋网-网眼尺寸-检查结果',
  `tie_rebar_skeleton_length_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋骨架-长-实际抽样数量',
  `tie_rebar_skeleton_length_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎钢筋骨架-长-检查记录',
  `tie_rebar_skeleton_length_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋骨架-长-检查结果',
  `tie_rebar_skeleton_width_height_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋骨架-宽高-实际抽样数量',
  `tie_rebar_skeleton_width_height_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎钢筋骨架-宽高-检查记录',
  `tie_rebar_skeleton_width_height_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎钢筋骨架-宽高-检查结果',
  `longitudinal_rebar_anchorage_length_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-锚固长度-实际抽样数量',
  `longitudinal_rebar_anchorage_length_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '纵向受力钢筋-锚固长度-检查记录',
  `longitudinal_rebar_anchorage_length_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-锚固长度-检查结果',
  `longitudinal_rebar_spacing_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-间距-实际抽样数量',
  `longitudinal_rebar_spacing_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '纵向受力钢筋-间距-检查记录',
  `longitudinal_rebar_spacing_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-间距-检查结果',
  `longitudinal_rebar_row_spacing_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-排距-实际抽样数量',
  `longitudinal_rebar_row_spacing_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '纵向受力钢筋-排距-检查记录',
  `longitudinal_rebar_row_spacing_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纵向受力钢筋-排距-检查结果',
  `concrete_foundation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-基础-实际抽样数量',
  `concrete_foundation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '混凝土保护层-基础-检查记录',
  `concrete_foundation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-基础-检查结果',
  `concrete_beam_column_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-柱梁-实际抽样数量',
  `concrete_beam_column_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '混凝土保护层-柱梁-检查记录',
  `concrete_beam_column_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-柱梁-检查结果',
  `concrete_cover_layer_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-保护层-实际抽样数量',
  `concrete_cover_layer_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '混凝土保护层-保护层-检查记录',
  `concrete_cover_layer_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '混凝土保护层-保护层-检查结果',
  `tie_stirrup_spacing_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎箍筋横向钢筋-间距-实际抽样数量',
  `tie_stirrup_spacing_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '绑扎箍筋横向钢筋-间距-检查记录',
  `tie_stirrup_spacing_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑扎箍筋横向钢筋-间距-检查结果',
  `rebar_bending_start_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋弯起点位置-实际抽样数量',
  `rebar_bending_start_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '钢筋弯起点位置-检查记录',
  `rebar_bending_start_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋弯起点位置-检查结果',
  `embedded_parts_centerline_position_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-中心线位置-实际抽样数量',
  `embedded_parts_centerline_position_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-中心线位置-检查记录',
  `embedded_parts_centerline_position_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-中心线位置-检查结果',
  `embedded_parts_centerline_position_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-中心线位置-照片',
  `embedded_parts_horizontal_elevation_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-水平高差-实际抽样数量',
  `embedded_parts_horizontal_elevation_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-水平高差-检查记录',
  `embedded_parts_horizontal_elevation_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-水平高差-检查结果',
  `embedded_parts_horizontal_elevation_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预埋件-水平高差-照片',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋安装数据记录表';
CREATE TABLE `data_rebar_material` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  `rebar_appearance_number` int DEFAULT NULL COMMENT '项目1-钢筋外观质量-实际抽样数量',
  `rebar_appearance_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目1-钢筋外观质量-检查记录',
  `rebar_appearance_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目1-钢筋外观质量-检查结果',
  `formed_rebar_appearance_dimension_number` int DEFAULT NULL COMMENT '项目2.1-成型钢筋外观质量-实际抽样数量',
  `formed_rebar_appearance_dimension_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目2.1-成型钢筋外观质量-检查记录',
  `formed_rebar_appearance_dimension_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目2.1-成型钢筋外观质量-检查结果',
  `rebar_connection_parts_number` int DEFAULT NULL COMMENT '项目3-钢筋机械连接套筒等外观质量-实际抽样数量',
  `rebar_connection_parts_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目3-钢筋机械连接套筒等外观质量-检查记录',
  `rebar_connection_parts_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目3-钢筋机械连接套筒等外观质量-检查结果',
  `rebar_appearance_photo_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目1-钢筋外观质量-照片URL',
  `formed_rebar_appearance_photo_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目2.1-成型钢筋外观质量-照片URL',
  `rebar_connection_parts_pdf_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目3-钢筋机械连接套筒等外观质量-PDF文件URL',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋原材料数据表';
CREATE TABLE `data_rebar_process` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `add_user` bigint DEFAULT NULL COMMENT '添加数据的用户id',
  `rebar_bend_arc_diameter_number` int DEFAULT NULL COMMENT '项目1-钢筋弯折的弯弧内直径-实际抽样数量',
  `rebar_bend_arc_diameter_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目1-钢筋弯折的弯弧内直径-检查记录',
  `rebar_bend_arc_diameter_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目1-钢筋弯折的弯弧内直径-检查结果',
  `longitudinal_rebar_bend_number` int DEFAULT NULL COMMENT '项目2-纵向受力钢筋的弯折-实际抽样数量',
  `longitudinal_rebar_bend_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目2-纵向受力钢筋的弯折-检查记录',
  `longitudinal_rebar_bend_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目2-纵向受力钢筋的弯折-检查结果',
  `stirrup_end_hook_number` int DEFAULT NULL COMMENT '项目3-箍筋拉筋的末端弯钩-实际抽样数量',
  `stirrup_end_hook_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目3-箍筋拉筋的末端弯钩-检查记录',
  `stirrup_end_hook_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目3-箍筋拉筋的末端弯钩-检查结果',
  `rebar_net_length_number` int DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-实际抽样数量',
  `rebar_net_length_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-检查记录',
  `rebar_net_length_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-检查结果',
  `bent_up_rebar_position_number` int DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-实际抽样数量',
  `bent_up_rebar_position_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-检查记录',
  `bent_up_rebar_position_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-检查结果',
  `stirrup_dimension_number` int DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-实际抽样数量',
  `stirrup_dimension_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-检查记录',
  `stirrup_dimension_result` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-检查结果',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋加工数据表';
CREATE TABLE `detail_inspection_original` (
  `inspection_data_id` bigint NOT NULL AUTO_INCREMENT,
  `task_id` bigint NOT NULL COMMENT '任务id',
  `task_item_id` int DEFAULT NULL COMMENT '【对端发送】',
  `task_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务类型（钢筋原材）',
  `inspection_item` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '【对端发送】验收项目名称（钢筋外观质量）',
  `fail_resample` varchar(32) NOT NULL DEFAULT '0' COMMENT '【对端发送】0为新任务，1为重新采集',
  `members` json DEFAULT NULL COMMENT '【对端发送】一个包含分发到任务的人员编码列表',
  `data_type` int DEFAULT NULL COMMENT '【对端发送】任务类型，拍照观察 note / 采集数据 data',
  `inspection_item_id` int DEFAULT NULL COMMENT '【对端发送】需要原样返回',
  `collector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '采集员名字',
  `inspect_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '检查部位',
  `part_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部位类别（墙、板、梁、柱、电梯间、楼梯、机械连接、独立基础）',
  `check_amount` int DEFAULT NULL COMMENT '实际抽样数量x',
  `passed_amount` int DEFAULT NULL COMMENT '合格数量',
  `is_passed` int DEFAULT NULL COMMENT '是否直接合格',
  `check_record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '验收记录x',
  `photo_capture_date` datetime DEFAULT NULL COMMENT '拍摄日期',
  `photo_capture_part` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '拍摄部位',
  `photo_url` varchar(255) DEFAULT NULL COMMENT '照片url',
  `device_records` json DEFAULT NULL COMMENT '设备数据记录["value","ispassed"]',
  `extra_report_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '额外的报告编号',
  `min_sample` int DEFAULT NULL COMMENT '最小采样数量',
  PRIMARY KEY (`inspection_data_id` DESC) USING BTREE,
  UNIQUE KEY `uk_task_item` (`task_id`,`task_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `idempotent_requests` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `request_id` varchar(64) NOT NULL,
  `client_id` varchar(128) NOT NULL,
  `body_hash` char(64) NOT NULL,
  `response_cache` longtext,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_idem_request_id` (`request_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `projects` (
  `project_id` bigint NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `project_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `project_construction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '施工单位',
  `project_schedule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '工程计划时间',
  `project_members` json DEFAULT NULL COMMENT '成员编号列表',
  `subprojects` json DEFAULT NULL COMMENT '子工程名称列表',
  `project_inner_number` varchar(64) DEFAULT NULL COMMENT '发送过来的项目编号',
  PRIMARY KEY (`project_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `rebar_inspection_record` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint unsigned NOT NULL,
  `construction_unit` varchar(255) DEFAULT NULL,
  `serial_no` varchar(100) DEFAULT NULL,
  `rebar_spec` varchar(100) DEFAULT NULL,
  `joint_count` int DEFAULT NULL,
  `performance_level` varchar(50) DEFAULT NULL,
  `operator_name` varchar(100) DEFAULT NULL,
  `cut_spec_result` varchar(50) DEFAULT NULL,
  `mech_spec_result` varchar(50) DEFAULT NULL,
  `install_date_s` datetime DEFAULT NULL,
  `install_date_e` datetime DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `standard` varchar(100) DEFAULT NULL,
  `appearance_check` text,
  `press_values` json DEFAULT NULL,
  `checklist` json DEFAULT NULL,
  `construction_evaluation` text,
  `supervisor_conclusion` text,
  `remark` text,
  `tech_leader_name` varchar(100) DEFAULT NULL,
  `tech_leader_date` date DEFAULT NULL,
  `supervisor_engineer_name` varchar(100) DEFAULT NULL,
  `supervisor_engineer_date` date DEFAULT NULL,
  `recorder` varchar(100) DEFAULT NULL,
  `project_dept_seal_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_rebar_project_id` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `rmc_construction_record` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `project_id` bigint NOT NULL,
  `weather` varchar(20) DEFAULT NULL,
  `temperature` varchar(20) DEFAULT NULL,
  `page_no` int DEFAULT '1',
  `supply_unit` varchar(200) DEFAULT NULL,
  `design_strength` varchar(50) DEFAULT NULL,
  `mix_plant` varchar(200) DEFAULT NULL,
  `contact_phone` varchar(50) DEFAULT NULL,
  `pouring_date_s` datetime DEFAULT NULL,
  `pouring_date_e` datetime DEFAULT NULL,
  `slump` varchar(50) DEFAULT NULL,
  `continuous_time` varchar(50) DEFAULT NULL,
  `initial_setting` varchar(50) DEFAULT NULL,
  `cube_strength` varchar(50) DEFAULT NULL,
  `truck_nos` json DEFAULT NULL,
  `checklist` json DEFAULT NULL,
  `sampling_times` int DEFAULT NULL,
  `sampling_values` json DEFAULT NULL,
  `cube_groups_curr` int DEFAULT NULL,
  `cube_groups_mid` int DEFAULT NULL,
  `cube_groups_spl` int DEFAULT NULL,
  `rebar_value` varchar(50) DEFAULT NULL,
  `inspector_opin` text,
  `recorder` varchar(50) DEFAULT NULL,
  `is_true` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_rmc_project` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `standard_cast_in_situ_structure` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `appearance_severe_defects_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-严重缺陷-设计要求',
  `appearance_severe_defects_total` int DEFAULT NULL COMMENT '外观质量-严重缺陷-样本总数',
  `appearance_severe_defects_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-严重缺陷-最小抽样数量',
  `appearance_functional_deviation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-结构性能尺寸偏差-设计要求',
  `appearance_functional_deviation_total` int DEFAULT NULL COMMENT '外观质量-结构性能尺寸偏差-样本总数',
  `appearance_functional_deviation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-结构性能尺寸偏差-最小抽样数量',
  `appearance_general_defects_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-一般缺陷-设计要求',
  `appearance_general_defects_total` int DEFAULT NULL COMMENT '外观质量-一般缺陷-样本总数',
  `appearance_general_defects_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '外观质量-一般缺陷-最小抽样数量',
  `axis_position_overall_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-整体基础-设计要求',
  `axis_position_overall_total` int DEFAULT NULL COMMENT '轴线位置-整体基础-样本总数',
  `axis_position_overall_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-整体基础-最小抽样数量',
  `axis_position_independent_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-独立基础-设计要求',
  `axis_position_independent_total` int DEFAULT NULL COMMENT '轴线位置-独立基础-样本总数',
  `axis_position_independent_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-独立基础-最小抽样数量',
  `axis_position_column_wall_beam_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-柱墙梁-设计要求',
  `axis_position_column_wall_beam_total` int DEFAULT NULL COMMENT '轴线位置-柱墙梁-样本总数',
  `axis_position_column_wall_beam_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轴线位置-柱墙梁-最小抽样数量',
  `verticality_floor_height_under_6m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高≤6m-设计要求',
  `verticality_floor_height_under_6m_total` int DEFAULT NULL COMMENT '垂直度-层高≤6m-样本总数',
  `verticality_floor_height_under_6m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高≤6m-最小抽样数量',
  `verticality_floor_height_over_6m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高＞6m-设计要求',
  `verticality_floor_height_over_6m_total` int DEFAULT NULL COMMENT '垂直度-层高＞6m-样本总数',
  `verticality_floor_height_over_6m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-层高＞6m-最小抽样数量',
  `verticality_total_height_under_300m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＜300m-设计要求',
  `verticality_total_height_under_300m_total` int DEFAULT NULL COMMENT '垂直度-全高＜300m-样本总数',
  `verticality_total_height_under_300m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＜300m-最小抽样数量',
  `verticality_total_height_over_300m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＞300m-设计要求',
  `verticality_total_height_over_300m_total` int DEFAULT NULL COMMENT '垂直度-全高＞300m-样本总数',
  `verticality_total_height_over_300m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '垂直度-全高＞300m-最小抽样数量',
  `elevation_floor_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-层高-设计要求',
  `elevation_floor_height_total` int DEFAULT NULL COMMENT '标高-层高-样本总数',
  `elevation_floor_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-层高-最小抽样数量',
  `elevation_total_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-全高-设计要求',
  `elevation_total_height_total` int DEFAULT NULL COMMENT '标高-全高-样本总数',
  `elevation_total_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标高-全高-最小抽样数量',
  `section_dimension_foundation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-基础-设计要求',
  `section_dimension_foundation_total` int DEFAULT NULL COMMENT '截面尺寸-基础-样本总数',
  `section_dimension_foundation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-基础-最小抽样数量',
  `section_dimension_cwsb_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-柱梁板墙-设计要求',
  `section_dimension_cwsb_total` int DEFAULT NULL COMMENT '截面尺寸-柱梁板墙-样本总数',
  `section_dimension_cwsb_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-柱梁板墙-最小抽样数量',
  `section_dimension_stairs_step_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-楼梯踏步高差-设计要求',
  `section_dimension_stairs_step_height_total` int DEFAULT NULL COMMENT '截面尺寸-楼梯踏步高差-样本总数',
  `section_dimension_stairs_step_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '截面尺寸-楼梯踏步高差-最小抽样数量',
  `elevator_shaft_center_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-中心位置-设计要求',
  `elevator_shaft_center_position_total` int DEFAULT NULL COMMENT '电梯井-中心位置-样本总数',
  `elevator_shaft_center_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-中心位置-最小抽样数量',
  `elevator_shaft_dimensions_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-长宽尺寸-设计要求',
  `elevator_shaft_dimensions_total` int DEFAULT NULL COMMENT '电梯井-长宽尺寸-样本总数',
  `elevator_shaft_dimensions_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电梯井-长宽尺寸-最小抽样数量',
  `surface_flatness_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表面平整度-设计要求',
  `surface_flatness_total` int DEFAULT NULL COMMENT '表面平整度-样本总数',
  `surface_flatness_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '表面平整度-最小抽样数量',
  `embedded_part_plate_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋板-设计要求',
  `embedded_part_plate_position_total` int DEFAULT NULL COMMENT '预埋件-预埋板-样本总数',
  `embedded_part_plate_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋板-最小抽样数量',
  `embedded_part_bolt_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋螺栓-设计要求',
  `embedded_part_bolt_position_total` int DEFAULT NULL COMMENT '预埋件-预埋螺栓-样本总数',
  `embedded_part_bolt_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋螺栓-最小抽样数量',
  `embedded_part_pipe_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋管-设计要求',
  `embedded_part_pipe_position_total` int DEFAULT NULL COMMENT '预埋件-预埋管-样本总数',
  `embedded_part_pipe_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-预埋管-最小抽样数量',
  `embedded_part_other_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-其他-设计要求',
  `embedded_part_other_position_total` int DEFAULT NULL COMMENT '预埋件-其他-样本总数',
  `embedded_part_other_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预埋件-其他-最小抽样数量',
  `reserved_opening_centerline_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预留洞孔中心线位置-设计要求',
  `reserved_opening_centerline_position_total` int DEFAULT NULL COMMENT '预留洞孔中心线位置-样本总数',
  `reserved_opening_centerline_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预留洞孔中心线位置-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='现浇结构标准表';
CREATE TABLE `standard_concrete_construction` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `post_pour_strip_joint_method_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `post_pour_strip_joint_method_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `post_pour_strip_joint_method_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `post_pour_curing_measures_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `post_pour_curing_measures_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `post_pour_curing_measures_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='混凝土施工标准数据表';
CREATE TABLE `standard_concrete_mix` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `ready_mixed_concrete_quality_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `ready_mixed_concrete_quality_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `ready_mixed_concrete_quality_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `concrete_mix_segregation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `concrete_mix_segregation_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `concrete_mix_segregation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  `chloride_alkali_content_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-设计要求',
  `chloride_alkali_content_total` int DEFAULT NULL COMMENT '项目3-样本总数',
  `chloride_alkali_content_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-最小抽样数量',
  `first_use_mix_ratio_appraisal_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-设计要求',
  `first_use_mix_ratio_appraisal_total` int DEFAULT NULL COMMENT '项目4-样本总数',
  `first_use_mix_ratio_appraisal_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-最小抽样数量',
  `concrete_mix_consistency_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-1)-设计要求',
  `concrete_mix_consistency_total` int DEFAULT NULL COMMENT '项目(二-1)-样本总数',
  `concrete_mix_consistency_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-1)-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='混凝土拌合物标准表';
CREATE TABLE `standard_formwork_installation` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `material_appearance_spec_size_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `material_appearance_spec_size_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `material_appearance_spec_size_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `installation_quality_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `installation_quality_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `installation_quality_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  `post_poured_strip_setup_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-设计要求',
  `post_poured_strip_setup_total` int DEFAULT NULL COMMENT '项目3-样本总数',
  `post_poured_strip_setup_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-最小抽样数量',
  `support_post_on_soil_requirements_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-设计要求',
  `support_post_on_soil_requirements_total` int DEFAULT NULL COMMENT '项目4-样本总数',
  `support_post_on_soil_requirements_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-最小抽样数量',
  `formwork_seam_tightness_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-1)-设计要求',
  `formwork_seam_tightness_total` int DEFAULT NULL COMMENT '项目(二-1)-样本总数',
  `formwork_seam_tightness_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-1)-最小抽样数量',
  `release_agent_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-2)-设计要求',
  `release_agent_total` int DEFAULT NULL COMMENT '项目(二-2)-样本总数',
  `release_agent_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-2)-最小抽样数量',
  `camber_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-3)-设计要求',
  `camber_height_total` int DEFAULT NULL COMMENT '项目(二-3)-样本总数',
  `camber_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-3)-最小抽样数量',
  `multi_story_shoring_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-4)-设计要求',
  `multi_story_shoring_total` int DEFAULT NULL COMMENT '项目(二-4)-样本总数',
  `multi_story_shoring_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-4)-最小抽样数量',
  `fixed_embedded_parts_openings_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-5)-设计要求',
  `fixed_embedded_parts_openings_total` int DEFAULT NULL COMMENT '项目(二-5)-样本总数',
  `fixed_embedded_parts_openings_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目(二-5)-最小抽样数量',
  `deviation_embedded_centerline_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋中心线-设计要求',
  `deviation_embedded_centerline_total` int DEFAULT NULL COMMENT '偏差-预埋中心线-样本总数',
  `deviation_embedded_centerline_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋中心线-最小抽样数量',
  `deviation_embedded_pipe_hole_centerline_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋管孔中心线-设计要求',
  `deviation_embedded_pipe_hole_centerline_total` int DEFAULT NULL COMMENT '偏差-预埋管孔中心线-样本总数',
  `deviation_embedded_pipe_hole_centerline_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋管孔中心线-最小抽样数量',
  `deviation_rebar_insert_centerline_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋中心线-设计要求',
  `deviation_rebar_insert_centerline_total` int DEFAULT NULL COMMENT '偏差-插筋中心线-样本总数',
  `deviation_rebar_insert_centerline_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋中心线-最小抽样数量',
  `deviation_rebar_insert_exposed_length_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋外露长度-设计要求',
  `deviation_rebar_insert_exposed_length_total` int DEFAULT NULL COMMENT '偏差-插筋外露长度-样本总数',
  `deviation_rebar_insert_exposed_length_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-插筋外露长度-最小抽样数量',
  `deviation_embedded_bolt_centerline_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓中心线-设计要求',
  `deviation_embedded_bolt_centerline_total` int DEFAULT NULL COMMENT '偏差-预埋螺栓中心线-样本总数',
  `deviation_embedded_bolt_centerline_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓中心线-最小抽样数量',
  `deviation_embedded_bolt_exposed_length_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓外露长度-设计要求',
  `deviation_embedded_bolt_exposed_length_total` int DEFAULT NULL COMMENT '偏差-预埋螺栓外露长度-样本总数',
  `deviation_embedded_bolt_exposed_length_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预埋螺栓外露长度-最小抽样数量',
  `deviation_reserved_opening_centerline_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞中心线-设计要求',
  `deviation_reserved_opening_centerline_total` int DEFAULT NULL COMMENT '偏差-预留洞中心线-样本总数',
  `deviation_reserved_opening_centerline_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞中心线-最小抽样数量',
  `deviation_reserved_opening_dimensions_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞尺寸-设计要求',
  `deviation_reserved_opening_dimensions_total` int DEFAULT NULL COMMENT '偏差-预留洞尺寸-样本总数',
  `deviation_reserved_opening_dimensions_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '偏差-预留洞尺寸-最小抽样数量',
  `formwork_deviation_axis_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-轴线位置-设计要求',
  `formwork_deviation_axis_position_total` int DEFAULT NULL COMMENT '模板偏差-轴线位置-样本总数',
  `formwork_deviation_axis_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-轴线位置-最小抽样数量',
  `formwork_deviation_bottom_elevation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-底模上表面标高-设计要求',
  `formwork_deviation_bottom_elevation_total` int DEFAULT NULL COMMENT '模板偏差-底模上表面标高-样本总数',
  `formwork_deviation_bottom_elevation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-底模上表面标高-最小抽样数量',
  `formwork_deviation_internal_dimensions_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸-设计要求',
  `formwork_deviation_internal_dimensions_total` int DEFAULT NULL COMMENT '模板偏差-内部尺寸-样本总数',
  `formwork_deviation_internal_dimensions_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-内部尺寸-最小抽样数量',
  `formwork_deviation_stairs_step_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-楼梯相邻踏步高差-设计要求',
  `formwork_deviation_stairs_step_height_total` int DEFAULT NULL COMMENT '模板偏差-楼梯相邻踏步高差-样本总数',
  `formwork_deviation_stairs_step_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-楼梯相邻踏步高差-最小抽样数量',
  `formwork_deviation_verticality_under_6m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(<6m)-设计要求',
  `formwork_deviation_verticality_under_6m_total` int DEFAULT NULL COMMENT '模板偏差-垂直度(<6m)-样本总数',
  `formwork_deviation_verticality_under_6m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(<6m)-最小抽样数量',
  `formwork_deviation_verticality_over_6m_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(>6m)-设计要求',
  `formwork_deviation_verticality_over_6m_total` int DEFAULT NULL COMMENT '模板偏差-垂直度(>6m)-样本总数',
  `formwork_deviation_verticality_over_6m_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-垂直度(>6m)-最小抽样数量',
  `formwork_deviation_adjacent_surface_diff_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-相邻表面高低差-设计要求',
  `formwork_deviation_adjacent_surface_diff_total` int DEFAULT NULL COMMENT '模板偏差-相邻表面高低差-样本总数',
  `formwork_deviation_adjacent_surface_diff_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-相邻表面高低差-最小抽样数量',
  `formwork_deviation_surface_flatness_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-表面平整度-设计要求',
  `formwork_deviation_surface_flatness_total` int DEFAULT NULL COMMENT '模板偏差-表面平整度-样本总数',
  `formwork_deviation_surface_flatness_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模板偏差-表面平整度-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='模板安装标准数据表';
CREATE TABLE `standard_rebar_connect` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `rebar_connection_method_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `rebar_connection_method_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `rebar_connection_method_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `torque_and_diameter_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `torque_and_diameter_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `torque_and_diameter_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  `coupler_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-设计要求',
  `coupler_position_total` int DEFAULT NULL COMMENT '项目3-样本总数',
  `coupler_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-最小抽样数量',
  `coupler_appearance_quality_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-设计要求',
  `coupler_appearance_quality_total` int DEFAULT NULL COMMENT '项目4-样本总数',
  `coupler_appearance_quality_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-最小抽样数量',
  `coupler_area_percentage_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目5-设计要求',
  `coupler_area_percentage_total` int DEFAULT NULL COMMENT '项目5-样本总数',
  `coupler_area_percentage_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目5-最小抽样数量',
  `lap_splice_setting_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-设计要求',
  `lap_splice_setting_total` int DEFAULT NULL COMMENT '项目6-样本总数',
  `lap_splice_setting_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-最小抽样数量',
  `stirrup_setting_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目7-设计要求',
  `stirrup_setting_total` int DEFAULT NULL COMMENT '项目7-样本总数',
  `stirrup_setting_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目7-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋连接标准表';
CREATE TABLE `standard_rebar_installation` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `rebar_grade_spec_quantity_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `rebar_grade_spec_quantity_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `rebar_grade_spec_quantity_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `rebar_installation_anchoring_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `rebar_installation_anchoring_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `rebar_installation_anchoring_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  `tie_rebar_mesh_dimensions_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-1-1-设计要求',
  `tie_rebar_mesh_dimensions_total` int DEFAULT NULL COMMENT '项目3-1-1-样本总数',
  `tie_rebar_mesh_dimensions_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-1-1-最小抽样数量',
  `tie_rebar_mesh_size_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-1-2-设计要求',
  `tie_rebar_mesh_size_total` int DEFAULT NULL COMMENT '项目3-1-2-样本总数',
  `tie_rebar_mesh_size_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-1-2-最小抽样数量',
  `tie_rebar_skeleton_length_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-2-1-设计要求',
  `tie_rebar_skeleton_length_total` int DEFAULT NULL COMMENT '项目3-2-1-样本总数',
  `tie_rebar_skeleton_length_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-2-1-最小抽样数量',
  `tie_rebar_skeleton_width_height_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-2-2-设计要求',
  `tie_rebar_skeleton_width_height_total` int DEFAULT NULL COMMENT '项目3-2-2-样本总数',
  `tie_rebar_skeleton_width_height_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-2-2-最小抽样数量',
  `longitudinal_rebar_anchorage_length_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-1-设计要求',
  `longitudinal_rebar_anchorage_length_total` int DEFAULT NULL COMMENT '项目3-3-1-样本总数',
  `longitudinal_rebar_anchorage_length_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-1-最小抽样数量',
  `longitudinal_rebar_spacing_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-2-设计要求',
  `longitudinal_rebar_spacing_total` int DEFAULT NULL COMMENT '项目3-3-2-样本总数',
  `longitudinal_rebar_spacing_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-2-最小抽样数量',
  `longitudinal_rebar_row_spacing_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-3-设计要求',
  `longitudinal_rebar_row_spacing_total` int DEFAULT NULL COMMENT '项目3-3-3-样本总数',
  `longitudinal_rebar_row_spacing_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-3-3-最小抽样数量',
  `concrete_foundation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-4-设计要求',
  `concrete_foundation_total` int DEFAULT NULL COMMENT '项目3-4-样本总数',
  `concrete_foundation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-4-最小抽样数量',
  `concrete_beam_column_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-5-设计要求',
  `concrete_beam_column_total` int DEFAULT NULL COMMENT '项目3-5-样本总数',
  `concrete_beam_column_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-5-最小抽样数量',
  `concrete_cover_layer_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-6-设计要求',
  `concrete_cover_layer_total` int DEFAULT NULL COMMENT '项目3-6-样本总数',
  `concrete_cover_layer_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-6-最小抽样数量',
  `tie_stirrup_spacing_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-设计要求',
  `tie_stirrup_spacing_total` int DEFAULT NULL COMMENT '项目4-样本总数',
  `tie_stirrup_spacing_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目4-最小抽样数量',
  `rebar_bending_start_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目5-设计要求',
  `rebar_bending_start_position_total` int DEFAULT NULL COMMENT '项目5-样本总数',
  `rebar_bending_start_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目5-最小抽样数量',
  `embedded_parts_centerline_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-1-设计要求',
  `embedded_parts_centerline_position_total` int DEFAULT NULL COMMENT '项目6-1-样本总数',
  `embedded_parts_centerline_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-1-最小抽样数量',
  `embedded_parts_horizontal_elevation_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-2-设计要求',
  `embedded_parts_horizontal_elevation_total` int DEFAULT NULL COMMENT '项目6-2-样本总数',
  `embedded_parts_horizontal_elevation_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目6-2-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋安装标准表';
CREATE TABLE `standard_rebar_material` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `rebar_appearance_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋外观质量-设计要求',
  `rebar_appearance_total` int DEFAULT NULL COMMENT '钢筋外观质量-样本总数',
  `rebar_appearance_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋外观质量-最小抽样数量',
  `formed_rebar_appearance_dimension_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '成型钢筋外观质量和尺寸偏差-设计要求',
  `formed_rebar_appearance_dimension_total` int DEFAULT NULL COMMENT '成型钢筋外观质量和尺寸偏差-样本总数',
  `formed_rebar_appearance_dimension_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '成型钢筋外观质量和尺寸偏差-最小抽样数量',
  `rebar_connection_parts_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋机械连接套筒等外观质量-设计要求',
  `rebar_connection_parts_total` int DEFAULT NULL COMMENT '钢筋机械连接套筒等外观质量-样本总数',
  `rebar_connection_parts_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '钢筋机械连接套筒等外观质量-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋原材料标准数据表';
CREATE TABLE `standard_rebar_process` (
  `task_id` bigint NOT NULL COMMENT '任务ID，主键',
  `item_type` enum('主控','一般') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '条目类型',
  `rebar_bend_arc_diameter_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-设计要求',
  `rebar_bend_arc_diameter_total` int DEFAULT NULL COMMENT '项目1-样本总数',
  `rebar_bend_arc_diameter_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目1-最小抽样数量',
  `longitudinal_rebar_bend_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-设计要求',
  `longitudinal_rebar_bend_total` int DEFAULT NULL COMMENT '项目2-样本总数',
  `longitudinal_rebar_bend_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目2-最小抽样数量',
  `stirrup_end_hook_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-设计要求',
  `stirrup_end_hook_total` int DEFAULT NULL COMMENT '项目3-样本总数',
  `stirrup_end_hook_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目3-最小抽样数量',
  `rebar_net_length_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-设计要求',
  `rebar_net_length_total` int DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-样本总数',
  `rebar_net_length_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-受力钢筋净尺寸-最小抽样数量',
  `bent_up_rebar_position_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-设计要求',
  `bent_up_rebar_position_total` int DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-样本总数',
  `bent_up_rebar_position_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-弯起钢筋的弯折位置-最小抽样数量',
  `stirrup_dimension_require` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-设计要求',
  `stirrup_dimension_total` int DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-样本总数',
  `stirrup_dimension_min_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '子项目-箍筋外廓尺寸-最小抽样数量',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='钢筋加工标准表';
CREATE TABLE `task_type_item` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `task_type` varchar(64) NOT NULL,
  `item_en` varchar(128) NOT NULL,
  `item_zh` varchar(128) NOT NULL,
  `item_type` int NOT NULL COMMENT '验收项目的类型（1：直接合格，2：抽样数+合格数，3.设备导入（尺量））',
  `sort_order` int NOT NULL DEFAULT '0',
  `has_photo` tinyint(1) NOT NULL DEFAULT '0',
  `has_pdf` tinyint(1) NOT NULL DEFAULT '0',
  `record_template` varchar(255) DEFAULT NULL COMMENT '验收结果模版',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_type_item` (`task_type`,`item_en`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tasks` (
  `task_id` bigint NOT NULL,
  `project_inner_number` varchar(255) DEFAULT NULL COMMENT '【对端发送】项目内部编号',
  `project_id` bigint DEFAULT NULL COMMENT '验收任务所属工程id',
  `subproject_name` varchar(255) DEFAULT NULL COMMENT '【对端发送】子工程名称',
  `task_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '验收任务类型，依照此去查对应的检验批数据表和检验批标准表',
  `task_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '验收任务部位，如：1-8/A-H轴二层梁板梯（3.820m）',
  `task_deadline` datetime DEFAULT NULL COMMENT '任务截止时间',
  `task_starttime` datetime DEFAULT NULL COMMENT '任务开始事件',
  `task_state` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务完成状态，0为未完成，1为已完成',
  `inspect_items` json DEFAULT NULL COMMENT '任务包含的验收项目',
  `task_volume` json DEFAULT NULL COMMENT '检验批容量，["source","volume","info"]',
  `fail_resample` int DEFAULT NULL COMMENT '是否为总工要求重新采集，0为新任务，1为重新采集',
  `design_values` json DEFAULT NULL COMMENT '设计值',
  `inspect_rule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '验收依据',
  PRIMARY KEY (`task_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `user_project` (
  `user_id` bigint NOT NULL COMMENT '用户id',
  `project_id` bigint NOT NULL COMMENT '工程id',
  `project_role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户在工程中的角色',
  PRIMARY KEY (`user_id`,`project_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `user_task_inspection` (
  `user_id` bigint NOT NULL COMMENT '`user`表id字段',
  `task_id` bigint DEFAULT NULL,
  `inspection_data_id` int DEFAULT NULL COMMENT '`detail_inspection_original`表inspection_data_id',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_code` varchar(64) NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'DATA_COLLECTOR',
  `company_name` varchar(255) DEFAULT NULL,
  `external_pwd_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '保存对端传来的双MD5/Base64串',
  `external_pwd_algo` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '口令来源算法标识，如 "MD5x2" / "BASE64" / "UNKNOWN"',
  `last_sync_at` timestamp NULL DEFAULT NULL COMMENT '最近同步时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '最近更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
BEGIN;
LOCK TABLES `inspection_db`.`according` WRITE;
DELETE FROM `inspection_db`.`according`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`client_apps` WRITE;
DELETE FROM `inspection_db`.`client_apps`;
INSERT INTO `inspection_db`.`client_apps` (`id`,`client_id`,`client_secret`,`hmac_secret`,`scopes`,`rate_limit_per_min`,`active`,`created_at`,`updated_at`) VALUES (1, 'demo', 'demo', NULL, 'users:sync projects:sync tasks:sync push:send', 600, 1, '2025-08-24 09:11:58', '2025-08-24 09:11:58')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_cast_in_situ_structure` WRITE;
DELETE FROM `inspection_db`.`data_cast_in_situ_structure`;
INSERT INTO `inspection_db`.`data_cast_in_situ_structure` (`task_id`,`appearance_severe_defects_number`,`appearance_severe_defects_record`,`appearance_severe_defects_result`,`appearance_severe_defects_photos`,`appearance_functional_deviation_number`,`appearance_functional_deviation_record`,`appearance_functional_deviation_result`,`appearance_general_defects_number`,`appearance_general_defects_record`,`appearance_general_defects_result`,`axis_position_overall_number`,`axis_position_overall_record`,`axis_position_overall_result`,`axis_position_independent_number`,`axis_position_independent_record`,`axis_position_independent_result`,`axis_position_column_wall_beam_number`,`axis_position_column_wall_beam_record`,`axis_position_column_wall_beam_result`,`verticality_floor_height_under_6m_number`,`verticality_floor_height_under_6m_record`,`verticality_floor_height_under_6m_result`,`verticality_floor_height_over_6m_number`,`verticality_floor_height_over_6m_record`,`verticality_floor_height_over_6m_result`,`verticality_total_height_under_300m_number`,`verticality_total_height_under_300m_record`,`verticality_total_height_under_300m_result`,`verticality_total_height_over_300m_number`,`verticality_total_height_over_300m_record`,`verticality_total_height_over_300m_result`,`elevation_floor_height_number`,`elevation_floor_height_record`,`elevation_floor_height_result`,`elevation_total_height_number`,`elevation_total_height_record`,`elevation_total_height_result`,`section_dimension_foundation_number`,`section_dimension_foundation_record`,`section_dimension_foundation_result`,`section_dimension_cwsb_number`,`section_dimension_cwsb_record`,`section_dimension_cwsb_result`,`section_dimension_stairs_step_height_number`,`section_dimension_stairs_step_height_record`,`section_dimension_stairs_step_height_result`,`elevator_shaft_center_position_number`,`elevator_shaft_center_position_record`,`elevator_shaft_center_position_result`,`elevator_shaft_dimensions_number`,`elevator_shaft_dimensions_record`,`elevator_shaft_dimensions_result`,`surface_flatness_number`,`surface_flatness_record`,`surface_flatness_result`,`embedded_part_plate_position_number`,`embedded_part_plate_position_record`,`embedded_part_plate_position_result`,`embedded_part_bolt_position_number`,`embedded_part_bolt_position_record`,`embedded_part_bolt_position_result`,`embedded_part_pipe_position_number`,`embedded_part_pipe_position_record`,`embedded_part_pipe_position_result`,`embedded_part_other_position_number`,`embedded_part_other_position_record`,`embedded_part_other_position_result`,`reserved_opening_centerline_position_number`,`reserved_opening_centerline_position_record`,`reserved_opening_centerline_position_result`,`reserved_opening_centerline_position_photos`,`add_user`) VALUES (107, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6', '轴线偏差实测值满足允许偏差', '合格', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_concrete_construction` WRITE;
DELETE FROM `inspection_db`.`data_concrete_construction`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_concrete_mix` WRITE;
DELETE FROM `inspection_db`.`data_concrete_mix`;
INSERT INTO `inspection_db`.`data_concrete_mix` (`task_id`,`ready_mixed_concrete_quality_number`,`ready_mixed_concrete_quality_record`,`ready_mixed_concrete_quality_result`,`ready_mixed_concrete_quality_pdf`,`concrete_mix_segregation_number`,`concrete_mix_segregation_record`,`concrete_mix_segregation_result`,`chloride_alkali_content_number`,`chloride_alkali_content_record`,`chloride_alkali_content_result`,`chloride_alkali_content_pdf`,`first_use_mix_ratio_appraisal_number`,`first_use_mix_ratio_appraisal_record`,`first_use_mix_ratio_appraisal_result`,`first_use_mix_ratio_appraisal_pdf`,`concrete_mix_consistency_number`,`concrete_mix_consistency_record`,`concrete_mix_consistency_result`,`add_user`) VALUES (105, '3', '出厂合格证、配合比通知单齐全', '合格', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_formwork_installation` WRITE;
DELETE FROM `inspection_db`.`data_formwork_installation`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_rebar_connect` WRITE;
DELETE FROM `inspection_db`.`data_rebar_connect`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_rebar_installation` WRITE;
DELETE FROM `inspection_db`.`data_rebar_installation`;
INSERT INTO `inspection_db`.`data_rebar_installation` (`task_id`,`add_user`,`rebar_grade_spec_quantity_number`,`rebar_grade_spec_quantity_record`,`rebar_grade_spec_quantity_result`,`rebar_installation_anchoring_number`,`rebar_installation_anchoring_record`,`rebar_installation_anchoring_result`,`tie_rebar_mesh_dimensions_number`,`tie_rebar_mesh_dimensions_record`,`tie_rebar_mesh_dimensions_result`,`tie_rebar_mesh_size_number`,`tie_rebar_mesh_size_record`,`tie_rebar_mesh_size_result`,`tie_rebar_skeleton_length_number`,`tie_rebar_skeleton_length_record`,`tie_rebar_skeleton_length_result`,`tie_rebar_skeleton_width_height_number`,`tie_rebar_skeleton_width_height_record`,`tie_rebar_skeleton_width_height_result`,`longitudinal_rebar_anchorage_length_number`,`longitudinal_rebar_anchorage_length_record`,`longitudinal_rebar_anchorage_length_result`,`longitudinal_rebar_spacing_number`,`longitudinal_rebar_spacing_record`,`longitudinal_rebar_spacing_result`,`longitudinal_rebar_row_spacing_number`,`longitudinal_rebar_row_spacing_record`,`longitudinal_rebar_row_spacing_result`,`concrete_foundation_number`,`concrete_foundation_record`,`concrete_foundation_result`,`concrete_beam_column_number`,`concrete_beam_column_record`,`concrete_beam_column_result`,`concrete_cover_layer_number`,`concrete_cover_layer_record`,`concrete_cover_layer_result`,`tie_stirrup_spacing_number`,`tie_stirrup_spacing_record`,`tie_stirrup_spacing_result`,`rebar_bending_start_position_number`,`rebar_bending_start_position_record`,`rebar_bending_start_position_result`,`embedded_parts_centerline_position_number`,`embedded_parts_centerline_position_record`,`embedded_parts_centerline_position_result`,`embedded_parts_centerline_position_photos`,`embedded_parts_horizontal_elevation_number`,`embedded_parts_horizontal_elevation_record`,`embedded_parts_horizontal_elevation_result`,`embedded_parts_horizontal_elevation_photos`) VALUES (103, NULL, NULL, '经直接观察，判定为：合格', '合格', NULL, '经直接观察，判定为：合格', '合格', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_rebar_material` WRITE;
DELETE FROM `inspection_db`.`data_rebar_material`;
INSERT INTO `inspection_db`.`data_rebar_material` (`task_id`,`add_user`,`rebar_appearance_number`,`rebar_appearance_record`,`rebar_appearance_result`,`formed_rebar_appearance_dimension_number`,`formed_rebar_appearance_dimension_record`,`formed_rebar_appearance_dimension_result`,`rebar_connection_parts_number`,`rebar_connection_parts_record`,`rebar_connection_parts_result`,`rebar_appearance_photo_url`,`formed_rebar_appearance_photo_url`,`rebar_connection_parts_pdf_url`) VALUES (101, 1, 5, '全数检查，钢筋平直、无损伤，无锈蚀、油污', '合格', 5, '11111', '合格', NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`data_rebar_process` WRITE;
DELETE FROM `inspection_db`.`data_rebar_process`;
INSERT INTO `inspection_db`.`data_rebar_process` (`task_id`,`add_user`,`rebar_bend_arc_diameter_number`,`rebar_bend_arc_diameter_record`,`rebar_bend_arc_diameter_result`,`longitudinal_rebar_bend_number`,`longitudinal_rebar_bend_record`,`longitudinal_rebar_bend_result`,`stirrup_end_hook_number`,`stirrup_end_hook_record`,`stirrup_end_hook_result`,`rebar_net_length_number`,`rebar_net_length_record`,`rebar_net_length_result`,`bent_up_rebar_position_number`,`bent_up_rebar_position_record`,`bent_up_rebar_position_result`,`stirrup_dimension_number`,`stirrup_dimension_record`,`stirrup_dimension_result`) VALUES (102, 1, 8, '弯弧内径满足规范及设计要求', '合格', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`detail_inspection_original` WRITE;
DELETE FROM `inspection_db`.`detail_inspection_original`;
INSERT INTO `inspection_db`.`detail_inspection_original` (`inspection_data_id`,`task_id`,`task_item_id`,`task_type`,`inspection_item`,`fail_resample`,`members`,`data_type`,`inspection_item_id`,`collector`,`inspect_part`,`part_type`,`check_amount`,`passed_amount`,`is_passed`,`check_record`,`photo_capture_date`,`photo_capture_part`,`photo_url`,`device_records`,`extra_report_number`,`min_sample`) VALUES (50, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(49, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(48, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(47, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(46, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(45, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(44, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(43, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(42, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(41, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(40, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(39, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(38, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(37, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(36, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(35, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(34, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(33, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(32, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(31, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(30, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, NULL),(29, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, NULL, '11111', NULL, NULL, NULL, NULL, NULL, NULL),(28, 101, 1001, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, 1),(27, 101, 1002, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '11111', NULL, NULL, NULL, NULL, NULL, 1),(26, 101, 1003, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, 1),(25, 101, 1004, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '实抽5件，合格5件，合格率100%', NULL, NULL, NULL, NULL, NULL, 1),(24, 101, 1005, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, 1),(23, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, NULL, '实抽5件，合格5件，合格率100%', NULL, NULL, NULL, NULL, NULL, 1),(22, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, 1),(21, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '实抽5件，合格5件，合格率100%', NULL, NULL, NULL, NULL, NULL, 1),(20, 101, NULL, 'rebar_material', '钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, NULL, 1, '全数检查，钢筋平直、无损伤，无锈蚀、油污', NULL, NULL, NULL, NULL, NULL, 1),(19, 101, NULL, 'rebar_material', '成型钢筋外观质量', '0', NULL, NULL, NULL, 'test', NULL, NULL, 5, 5, NULL, '实抽5件，合格5件，合格率100%', NULL, NULL, NULL, NULL, NULL, 1),(18, 101, 1, 'rebar_material', '成型钢筋外观质量', '0', '[\"1\"]', NULL, 1, 'test', NULL, NULL, 5, NULL, NULL, '抽查3件，外观质量合格3件；尺寸偏差合格3件', NULL, NULL, NULL, NULL, NULL, 1),(17, 101, 2, 'rebar_material', '钢筋外观质量', '0', '[\"1\"]', NULL, 2, 'test', NULL, NULL, 5, NULL, 1, '钢筋表面无裂纹、无明显锈蚀', NULL, NULL, NULL, NULL, NULL, 1),(16, 103, 3, 'rebar_installation', '预埋件-水平高差mm', '0', '[\"1\", \"2\"]', 0, 3, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),(15, 103, 4, 'rebar_installation', '预埋件-中心线位置mm', '1', '[\"1\", \"2\"]', 0, 4, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(14, 103, 5, 'rebar_installation', '钢筋弯起点位置mm', '0', '[\"1\", \"2\"]', 0, 5, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(13, 103, 6, 'rebar_installation', '绑扎箍筋、横向钢筋间距mm', '1', '[\"1\", \"2\"]', 0, 6, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(12, 103, 7, 'rebar_installation', '纵向受力钢筋、箍筋的混凝土保护层厚度-板、墙、壳', '0', 'null', 0, 7, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(11, 103, 8, 'rebar_installation', '纵向受力钢筋、箍筋的混凝土保护层厚度-柱、梁', '0', 'null', 0, 8, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(10, 103, 9, 'rebar_installation', '纵向受力钢筋、箍筋的混凝土保护层厚度-基础', '0', 'null', 0, 9, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(9, 103, 10, 'rebar_installation', '纵向受力钢筋-排距mm', '0', 'null', 0, 10, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(8, 103, 11, 'rebar_installation', '纵向受力钢筋-间距mm', '0', 'null', 0, 11, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(7, 103, 12, 'rebar_installation', '纵向受力钢筋-锚固长度mm', '0', 'null', 0, 12, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(6, 103, 13, 'rebar_installation', '绑扎钢筋骨架-宽、高mm', '0', 'null', 0, 13, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(5, 103, 14, 'rebar_installation', '绑扎钢筋骨架-长mm', '0', 'null', 0, 14, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(4, 103, 15, 'rebar_installation', '绑扎钢筋网-网眼尺寸mm', '0', 'null', 0, 15, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(3, 103, 16, 'rebar_installation', '绑扎钢筋网-长、宽mm', '0', 'null', 0, 16, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),(2, 103, 17, 'rebar_installation', '受力钢筋的安装位置、锚固方式', '0', 'null', 0, 17, 'test', NULL, NULL, NULL, NULL, 1, '经直接观察，判定为：合格', NULL, NULL, NULL, NULL, NULL, NULL),(1, 103, 18, 'rebar_installation', '受力钢筋的牌号、规格和数量', '0', 'null', 0, 18, 'test', NULL, NULL, NULL, NULL, 1, '经直接观察，判定为：合格', NULL, NULL, NULL, NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`idempotent_requests` WRITE;
DELETE FROM `inspection_db`.`idempotent_requests`;
INSERT INTO `inspection_db`.`idempotent_requests` (`id`,`request_id`,`client_id`,`body_hash`,`response_cache`,`created_at`) VALUES (1, '881efdfb-7df5-4c01-8c33-33a36cc59b10', 'demo', '961bee107648f8b81487ea1f9b5f4d494e9900c1bc62babc85564dd02ec56b2a', '{\"code\":\"200\",\"msg\":\"请求成功\",\"detail\":[{\"user_code\":\"U001\",\"is_success\":true,\"error\":null},{\"user_code\":\"U002\",\"is_success\":true,\"error\":null}]}', '2025-09-10 14:17:31'),(4, '3a004954-9e4f-4341-9b4b-edd4559649be', 'demo', 'fe1eee67c22593207e8c72a1321e46c4b3c690b00233ee34f7ac1dd4db355e63', '{\"code\":\"200\",\"msg\":\"请求成功\",\"detail\":[{\"project_inner_number\":\"P001\",\"is_success\":true,\"error\":null},{\"project_inner_number\":\"P002\",\"is_success\":true,\"error\":null}]}', '2025-09-10 14:51:32'),(5, '90174b51-e74c-4260-86f2-25d773402494', 'demo', 'fe1eee67c22593207e8c72a1321e46c4b3c690b00233ee34f7ac1dd4db355e63', '{\"code\":\"200\",\"msg\":\"请求成功\",\"detail\":[{\"project_inner_number\":\"P001\",\"is_success\":true,\"error\":null},{\"project_inner_number\":\"P002\",\"is_success\":true,\"error\":null}]}', '2025-09-11 07:29:56'),(6, '7aa8df77-cf99-41df-8bac-93bcd728386a', 'demo', '9d57482a7ce7714026c28943aa276fb0da0e0de23482f5be458a02a68c644b46', '{\"code\":\"200\",\"msg\":\"请求成功\",\"detail\":[{\"project_inner_number\":\"P001\",\"is_success\":true,\"error\":null},{\"project_inner_number\":\"P002\",\"is_success\":true,\"error\":null}]}', '2025-09-11 07:39:11')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`projects` WRITE;
DELETE FROM `inspection_db`.`projects`;
INSERT INTO `inspection_db`.`projects` (`project_id`,`project_name`,`project_address`,`project_construction`,`project_schedule`,`project_members`,`subprojects`,`project_inner_number`) VALUES (1, '中建五局一公司综合楼-主体结构工程', '西安市雁塔区A地块', '中建五局一公司', '2025-08 ~ 2026-03', '[\"001\"]', '[\"主体结构分部\"]', NULL),(2, '中建五局一公司综合楼-基础工程', '西安市雁塔区A地块', '中建五局一公司', '2025-08 ~ 2025-11', '[\"002\"]', '[\"主体结构分部2\"]', NULL),(5, '图书馆改造', NULL, NULL, NULL, '[\"U001\", \"U002\", \"U003\"]', '[\"地基处理\", \"主体结构\"]', 'P001'),(6, '综合楼施工', NULL, NULL, NULL, '[\"U002\", \"U004\"]', '[\"钢结构\", \"机电安装\"]', 'P002')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`rebar_inspection_record` WRITE;
DELETE FROM `inspection_db`.`rebar_inspection_record`;
INSERT INTO `inspection_db`.`rebar_inspection_record` (`id`,`project_id`,`construction_unit`,`serial_no`,`rebar_spec`,`joint_count`,`performance_level`,`operator_name`,`cut_spec_result`,`mech_spec_result`,`install_date_s`,`install_date_e`,`position`,`standard`,`appearance_check`,`press_values`,`checklist`,`construction_evaluation`,`supervisor_conclusion`,`remark`,`tech_leader_name`,`tech_leader_date`,`supervisor_engineer_name`,`supervisor_engineer_date`,`recorder`,`project_dept_seal_date`,`created_at`,`updated_at`) VALUES (1, 0, '11', '11', '11', 0, '11', '11', '11', '11', '2025-08-24 09:18:00', '2025-08-24 09:18:00', '11', '11', '111', '[111.0]', '[{\"no\": 1, \"title\": \"11\", \"result\": \"11\"}]', '111', '111', '111', '11', '2025-08-24', '11', '2025-08-24', '11', '2025-08-24', '2025-08-24 09:19:14', '2025-08-24 09:19:14'),(2, 0, '11', '11', '11', 11, '11', '11', '11', '11', '2025-08-24 09:36:00', '2025-08-24 09:36:00', '11', '11', '11', '[11.0]', '[{\"no\": 1, \"title\": \"11\", \"result\": \"11\"}]', '11', '11', '11', '11', '2025-08-24', '11', '2025-08-24', '11', '2025-08-24', '2025-08-24 09:37:13', '2025-08-24 09:37:13'),(3, 0, '111', '111', '111', 0, '111', '111', '1111', '111', '2025-08-24 09:57:00', '2025-08-24 09:57:00', '111', '111', '111', '[11.0]', '[{\"no\": 1, \"title\": \"111\", \"result\": \"111\"}]', '111', '111', '111', '111', '2025-08-24', '11', '2025-08-24', '111', '2025-08-24', '2025-08-24 09:57:34', '2025-08-24 09:57:34'),(4, 0, '11', '1', '111', 0, '1', '1', '1', '1', NULL, NULL, '111', '111', '111', '[111.0]', '[{\"no\": 1, \"title\": \"1\", \"result\": \"1\"}]', '11', '11', '', '1', '2025-08-24', '11', '2025-08-24', '11', '2025-08-24', '2025-08-24 10:47:19', '2025-08-24 10:47:19'),(5, 0, '11', '11', '11', 0, '1', '1', '1', '1', '2025-08-24 11:03:00', '2025-08-24 11:03:00', '1', '1', '1', '[1.0]', '[{\"no\": 1, \"title\": \"1\", \"result\": \"1\"}]', '1', '1', '1', '1', '2025-08-24', '1', '2025-08-24', '1', '2025-08-24', '2025-08-24 11:03:56', '2025-08-24 11:03:56'),(6, 0, '1', '1', '1', 0, '1', '1', '1', '1', '2025-08-24 11:57:00', '2025-08-24 11:57:00', '1', '1', '11', '[11.0]', '[{\"no\": 1, \"title\": \"1\", \"result\": \"1\"}]', '11', '11', '11', '11', '2025-08-24', '11', '2025-08-24', '11', '2025-08-24', '2025-08-24 11:58:27', '2025-08-24 11:58:27'),(7, 0, '中建五局', '111', '111', 0, '1级', '张三', '合格', '合格', '2025-09-11 07:25:00', '2025-09-11 07:25:00', '二楼', '111', '合格', '[]', '[]', '合格', '合格', '合格', '合格', '2025-09-11', '合格', '2025-09-11', '合格', '2025-09-11', '2025-09-11 07:26:11', '2025-09-11 07:26:11')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`rmc_construction_record` WRITE;
DELETE FROM `inspection_db`.`rmc_construction_record`;
INSERT INTO `inspection_db`.`rmc_construction_record` (`id`,`project_id`,`weather`,`temperature`,`page_no`,`supply_unit`,`design_strength`,`mix_plant`,`contact_phone`,`pouring_date_s`,`pouring_date_e`,`slump`,`continuous_time`,`initial_setting`,`cube_strength`,`truck_nos`,`checklist`,`sampling_times`,`sampling_values`,`cube_groups_curr`,`cube_groups_mid`,`cube_groups_spl`,`rebar_value`,`inspector_opin`,`recorder`,`is_true`,`created_at`,`updated_at`) VALUES (1, 0, '11', '11', 1, '11', '11', '11', '11', NULL, NULL, '11', '11', '11', '11', '[\"11\"]', '[{\"no\": 1, \"title\": \"11\", \"result\": \"11\"}]', 0, '[11.0]', 0, 0, 0, '11', NULL, '111', NULL, '2025-08-24 04:48:26', '2025-08-24 04:48:26'),(2, 0, '111', '111', 1, '111', '111', '111', '111', NULL, NULL, '111', '111', '111', '111', '[\"111\"]', '[{\"no\": 1, \"title\": \"11\", \"result\": \"111\"}]', 0, '[111.0]', 0, 0, 0, '11', NULL, '111', NULL, '2025-08-24 06:38:28', '2025-08-24 06:38:28'),(3, 0, '11', '11', 1, '11', '11', '11', '11', NULL, NULL, '11', '11', '11', '11', '[\"111\"]', '[{\"no\": 1, \"title\": \"11\", \"result\": \"11\"}]', 0, '[11.0]', 0, 0, 0, '11', NULL, '111', NULL, '2025-08-24 07:02:50', '2025-08-24 07:02:50'),(4, 0, '111', '111', 1, '111', '111', '111', '111', NULL, NULL, '111', '111', '111', '111', '[\"111\"]', '[{\"no\": 1, \"title\": \"111\", \"result\": \"111\"}]', 0, '[111.0]', 0, 0, 0, '111', NULL, '111', NULL, '2025-08-24 07:28:11', '2025-08-24 07:28:11'),(5, 0, '1', '1', 1, '1', '1', '11', '1', NULL, NULL, '1', '1', '1', '1', '[\"1\"]', '[{\"no\": 1, \"title\": \"1\", \"result\": \"1\"}]', 0, '[1.0]', 0, 0, 0, '1', NULL, '11', NULL, '2025-08-24 08:00:41', '2025-08-24 08:00:41'),(6, 0, '11', '11', 1, '1', '1', '1', '1', NULL, NULL, '11', '11', '11', '11', '[\"1111\"]', '[{\"no\": 1, \"title\": \"1\", \"result\": \"1\"}]', 1, '[11.0]', 0, 0, 0, '', NULL, '11', NULL, '2025-08-24 10:51:45', '2025-08-24 10:51:45'),(7, 0, '11', '11', 1, '11', '11', '11', '11', NULL, NULL, '11', '11', '11', '11', '[\"11\"]', '[]', 1, '[]', 0, 0, 0, '', NULL, '111', NULL, '2025-09-10 08:41:17', '2025-09-10 08:41:17'),(8, 0, '阴', '2', 1, '部位', '45', '一号', '111', NULL, NULL, '111', '111', '1小时', '11', '[\"111\"]', '[]', 0, '[]', 0, 0, 0, '11', NULL, '合格', NULL, '2025-09-11 07:27:50', '2025-09-11 07:27:50')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_cast_in_situ_structure` WRITE;
DELETE FROM `inspection_db`.`standard_cast_in_situ_structure`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_concrete_construction` WRITE;
DELETE FROM `inspection_db`.`standard_concrete_construction`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_concrete_mix` WRITE;
DELETE FROM `inspection_db`.`standard_concrete_mix`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_formwork_installation` WRITE;
DELETE FROM `inspection_db`.`standard_formwork_installation`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_rebar_connect` WRITE;
DELETE FROM `inspection_db`.`standard_rebar_connect`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_rebar_installation` WRITE;
DELETE FROM `inspection_db`.`standard_rebar_installation`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_rebar_material` WRITE;
DELETE FROM `inspection_db`.`standard_rebar_material`;
INSERT INTO `inspection_db`.`standard_rebar_material` (`task_id`,`item_type`,`rebar_appearance_require`,`rebar_appearance_total`,`rebar_appearance_min_number`,`formed_rebar_appearance_dimension_require`,`formed_rebar_appearance_dimension_total`,`formed_rebar_appearance_dimension_min_number`,`rebar_connection_parts_require`,`rebar_connection_parts_total`,`rebar_connection_parts_min_number`) VALUES (101, '一般', '第5.2.4条', 5, '5', '第5.2.5条', 5, '5', '第5.2.6条', 3, '全')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`standard_rebar_process` WRITE;
DELETE FROM `inspection_db`.`standard_rebar_process`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`task_type_item` WRITE;
DELETE FROM `inspection_db`.`task_type_item`;
INSERT INTO `inspection_db`.`task_type_item` (`id`,`task_type`,`item_en`,`item_zh`,`item_type`,`sort_order`,`has_photo`,`has_pdf`,`record_template`) VALUES (1, 'rebar_material', 'rebar_appearance', '钢筋外观质量', 1, 10, 1, 0, '全数检查，钢筋平直、无损伤，无锈蚀、油污'),(2, 'rebar_material', 'formed_rebar_appearance_dimension', '成型钢筋外观质量', 2, 20, 1, 0, NULL),(4, 'rebar_material', 'rebar_connection_parts', '钢筋机械连接套筒', 1, 40, 0, 1, '质量证明文件齐全，钢筋机械连接套筒外观质量符合标准要求'),(5, 'rebar_process', 'rebar_bend_arc_diameter', '钢筋弯折的弯弧内直径', 3, 10, 1, 0, ''),(6, 'rebar_process', 'longitudinal_rebar_bend', '纵向受力钢筋的弯折', 3, 20, 0, 1, ''),(7, 'rebar_process', 'stirrup_end_hook', '箍筋、拉筋的末端弯钩', 3, 30, 0, 0, NULL),(8, 'rebar_process', 'rebar_net_length', '钢筋加工的形状、尺寸-受力钢筋净尺寸mm', 3, 40, 0, 0, NULL),(9, 'rebar_process', 'bent_up_rebar_position', '钢筋加工的形状、尺寸-弯起钢筋的弯折位置mm', 3, 50, 0, 0, '板钢筋连接采用帮扎搭接；梁钢筋C18采用搭接焊接，C25钢筋采用直螺纹连接。全数检查，连接方式符合设计要求'),(10, 'rebar_process', 'stirrup_dimension', '钢筋加工的形状、尺寸-箍筋外廓尺寸mm', 3, 60, 0, 0, NULL),(11, 'rebar_connect', 'rebar_connection_method', '钢筋的连接方式', 1, 10, 0, 0, NULL),(12, 'rebar_connect', 'torque_and_diameter', '螺纹接头应检验拧紧扭矩值，挤压接头应量测压痕直径', 3, 20, 0, 0, '抽查*个，符合要求*个，仪器检查记录一份，直螺纹接头扭矩检查记录一份'),(13, 'rebar_connect', 'coupler_position', '钢筋接头的位置', 2, 30, 0, 0, '共*个构件，全数检查，合格*个构件'),(14, 'rebar_connect', 'coupler_appearance_quality', '钢筋机械连接接头和焊接接头的外观质量', 2, 40, 1, 0, '共有*个构件，全数检查，合格*个构件'),(15, 'rebar_connect', 'coupler_area_percentage', '机械连接接头和焊接的接头面积百分率', 2, 40, 0, 0, '抽查*件#，合格；接头面积百分率50%'),(16, 'rebar_connect', 'lap_splice_setting', '当纵向受力钢筋采用绑扎搭接接头时，接头的设置', 2, 50, 0, 0, '抽查*块#，合格；接头设置位置正确，接头面积百分率25%'),(17, 'rebar_connect', 'stirrup_setting', '梁、柱类构件的纵向受力钢筋搭接长度范围内箍筋的设置', 2, 60, 0, 0, '抽查*件#，纵向受力钢筋搭接长度范围内箍筋的设置合格；'),(18, 'rebar_installation', 'rebar_grade_spec_quantity', '受力钢筋的牌号、规格和数量', 1, 10, 0, 0, '全数检查，钢筋的牌号、规格、数量符合设计要求，隐蔽验收合格'),(19, 'rebar_installation', 'rebar_installation_anchoring', '受力钢筋的安装位置、锚固方式', 1, 20, 0, 0, '共*个构件，全数检查，符合设计要求'),(20, 'rebar_installation', 'tie_rebar_mesh_dimensions', '绑扎钢筋网-长、宽mm', 3, 30, 0, 0, NULL),(21, 'rebar_installation', 'tie_rebar_mesh_size', '绑扎钢筋网-网眼尺寸mm', 3, 40, 0, 0, NULL),(22, 'rebar_installation', 'tie_rebar_skeleton_length', '绑扎钢筋骨架-长mm', 3, 50, 0, 0, NULL),(23, 'rebar_installation', 'tie_rebar_skeleton_width_height', '绑扎钢筋骨架-宽、高mm', 3, 60, 0, 0, NULL),(24, 'rebar_installation', 'longitudinal_rebar_anchorage_length', '纵向受力钢筋-锚固长度mm', 3, 70, 0, 0, NULL),(25, 'rebar_installation', 'longitudinal_rebar_spacing', '纵向受力钢筋-间距mm', 3, 80, 0, 0, NULL),(26, 'rebar_installation', 'longitudinal_rebar_row_spacing', '纵向受力钢筋-排距mm', 3, 90, 0, 0, NULL),(27, 'rebar_installation', 'concrete_foundation', '纵向受力钢筋、箍筋的混凝土保护层厚度-基础', 3, 100, 0, 0, NULL),(28, 'rebar_installation', 'concrete_beam_column', '纵向受力钢筋、箍筋的混凝土保护层厚度-柱、梁', 3, 110, 0, 0, NULL),(29, 'rebar_installation', 'concrete_cover_layer', '纵向受力钢筋、箍筋的混凝土保护层厚度-板、墙、壳', 3, 120, 0, 0, NULL),(30, 'rebar_installation', 'tie_stirrup_spacing', '绑扎箍筋、横向钢筋间距mm', 3, 130, 0, 0, NULL),(31, 'rebar_installation', 'rebar_bending_start_position', '钢筋弯起点位置mm', 3, 140, 0, 0, NULL),(32, 'rebar_installation', 'embedded_parts_centerline_position', '预埋件-中心线位置mm', 3, 150, 0, 0, NULL),(33, 'rebar_installation', 'embedded_parts_horizontal_elevation', '预埋件-水平高差mm', 3, 160, 0, 0, NULL),(34, 'formwork_installation', 'material_appearance_spec_size', '模板和支架材料的外观、规格和尺寸', 1, 10, 0, 0, '合格证4份，材料进场验收记录4份，进场验收合格'),(35, 'formwork_installation', 'installation_quality', '模板及支架的安装质量', 1, 20, 0, 0, '全数检查，安装牢固、稳定，符合模版施工方案要求'),(36, 'formwork_installation', 'post_poured_strip_setup', '后浇带处的模板及支架设置', 1, 30, 0, 0, '全数检查，后浇带处的模板及支架独立设置，符合模版施工方案要求'),(37, 'formwork_installation', 'support_post_on_soil_requirements', '支架竖杆和竖向模板安装在土层上的要求', 1, 40, 0, 0, '全数检查，土层坚实、平整，有防水、排水措施，支架竖杆下有垫板，符合模版施工方案要求'),(38, 'formwork_installation', 'formwork_seam_tightness', '模板安装的质量要求', 1, 50, 0, 0, '全数检查，模板接缝严密，模内无杂物'),(39, 'formwork_installation', 'release_agent', '隔离剂的品种和涂刷方法、避免隔离剂沾污、造成污染', 1, 60, 0, 0, '梁20件，抽查梁3件：抽查3处，合格3处；板30间，抽查板3间：抽查3处，合格3处'),(40, 'formwork_installation', 'camber_height', '模板起拱高度', 3, 70, 0, 0, '全数检查，模板支设符合方案要求，上下层竖杆基本对准，设垫板'),(41, 'formwork_installation', 'multi_story_shoring', '现浇混凝土结构多层连续支模、支架的竖杆、垫板要求', 1, 80, 0, 0, '全数检查，安装牢固、稳定，符合模版施工方案要求'),(42, 'formwork_installation', 'fixed_embedded_parts_openings', '固定在模板上的预埋件和预留孔洞', 1, 90, 0, 0, NULL),(43, 'formwork_installation', 'deviation_embedded_centerline', '预埋件和预留孔洞的安装允许偏差-预埋中心线位置mm', 3, 100, 0, 0, NULL),(44, 'formwork_installation', 'deviation_embedded_pipe_hole_centerline', '预埋件和预留孔洞的安装允许偏差-预埋管、预留孔中心线位置mm', 3, 110, 0, 0, NULL),(45, 'formwork_installation', 'deviation_rebar_insert_centerline', '预埋件和预留孔洞的安装允许偏差-插筋-中心线位置mm', 3, 120, 0, 0, NULL),(46, 'formwork_installation', 'deviation_rebar_insert_exposed_length', '预埋件和预留孔洞的安装允许偏差-插筋-外露长度mm', 3, 130, 0, 0, NULL),(47, 'formwork_installation', 'deviation_embedded_bolt_centerline', '预埋件和预留孔洞的安装允许偏差-预埋螺栓-中心线位置mm', 3, 140, 0, 0, NULL),(48, 'formwork_installation', 'deviation_embedded_bolt_exposed_length', '预埋件和预留孔洞的安装允许偏差-预埋螺栓-外露长度mm', 3, 150, 0, 0, NULL),(49, 'formwork_installation', 'deviation_reserved_opening_centerline', '预埋件和预留孔洞的安装允许偏差-预留洞-中心线位置mm', 3, 160, 0, 0, NULL),(50, 'formwork_installation', 'deviation_reserved_opening_dimensions', '预埋件和预留孔洞的安装允许偏差-预留洞-尺寸mm', 3, 170, 0, 0, NULL),(51, 'formwork_installation', 'formwork_deviation_axis_position', '模板安装允许偏差-轴线位置', 2, 180, 0, 0, NULL),(52, 'formwork_installation', 'formwork_deviation_bottom_elevation', '模板安装允许偏差-底模上表面标高mm', 2, 190, 0, 0, NULL),(53, 'formwork_installation', 'formwork_deviation_internal_basic_dimensions', '模板安装允许偏差-模板内部尺寸mm-基础', 2, 200, 0, 0, NULL),(54, 'formwork_installation', 'formwork_deviation_internal_dimensions', '模板安装允许偏差-模板内部尺寸mm-柱、墙、梁', 2, 210, 0, 0, NULL),(55, 'formwork_installation', 'formwork_deviation_stairs_step_height', '模板安装允许偏差-模板内部尺寸mm-楼梯相邻踏步高差', 2, 220, 0, 0, NULL),(56, 'formwork_installation', 'formwork_deviation_verticality_under_6m', '模板安装允许偏差-柱、墙垂直度mm-层高≤6m', 2, 230, 0, 0, NULL),(57, 'formwork_installation', 'formwork_deviation_verticality_over_6m', '模板安装允许偏差-柱、墙垂直度mm-层高＞6m', 2, 240, 0, 0, NULL),(58, 'formwork_installation', 'formwork_deviation_adjacent_surface_diff', '模板安装允许偏差-相邻模板表面高低差mm', 2, 250, 0, 0, NULL),(59, 'formwork_installation', 'formwork_deviation_surface_flatness', '模板安装允许偏差-表面平整度mm', 2, 260, 0, 0, NULL),(60, 'concrete_mix', 'ready_mixed_concrete_quality', '预拌混凝土质量', 1, 10, 0, 1, '配合比通知单1份，强度试验报告1份，合格证1份，搅拌运输单15份'),(61, 'concrete_mix', 'concrete_mix_segregation', '混凝土拌合物不应离析', 2, 20, 0, 0, '共15车，全数检查，合格15车'),(62, 'concrete_mix', 'chloride_alkali_content', '混凝土中氯离子含量和碱总量', 1, 30, 0, 1, '质量证明文件齐全有效'),(63, 'concrete_mix', 'first_use_mix_ratio_appraisal', '首次使用的混凝土配合比应进行开盘鉴定', 1, 40, 0, 0, '质量证明文件齐全有效'),(64, 'concrete_mix', 'concrete_mix_consistency', '混凝土拌合物稠度', 1, 50, 0, 0, '检验合格，记录编号'),(65, 'cast_in_situ_structure', 'appearance_severe_defects', '现浇结构的外观质量不应有严重缺陷', 1, 10, 1, 0, '全数检查，混凝土外观无严重缺陷'),(66, 'cast_in_situ_structure', 'appearance_functional_deviation', '现浇结构不应有影响结构性能或使用功能的尺寸偏差', 1, 20, 0, 0, '全数检查，无影响结构性能或使用功能的尺寸偏差'),(67, 'cast_in_situ_structure', 'appearance_general_defects', '现浇结构的外观质量不应有一般缺陷', 1, 30, 0, 0, '全数检查，混凝土外观无一般缺陷'),(68, 'cast_in_situ_structure', 'axis_position_overall', '轴线位置mm-整体基础', 3, 40, 0, 0, ''),(69, 'cast_in_situ_structure', 'axis_position_independent', '轴线位置mm-独立基础', 3, 50, 0, 0, NULL),(70, 'cast_in_situ_structure', 'axis_position_column_wall_beam', '轴线位置mm-柱、墙、梁', 3, 60, 0, 0, NULL),(71, 'cast_in_situ_structure', 'verticality_floor_height_under_6m', '垂直度mm-层高≤6m', 3, 70, 0, 0, NULL),(72, 'cast_in_situ_structure', 'verticality_floor_height_over_6m', '垂直度mm-层高＞6m', 3, 80, 0, 0, NULL),(73, 'cast_in_situ_structure', 'verticality_total_height_under_300m', '垂直度mm-全高(H)≤300m', 3, 90, 0, 0, NULL),(74, 'cast_in_situ_structure', 'verticality_total_height_over_300m', '垂直度mm-全高(H)＞300m', 3, 100, 0, 0, NULL),(75, 'cast_in_situ_structure', 'elevation_floor_height', '标高mm-层高', 3, 110, 0, 0, NULL),(76, 'cast_in_situ_structure', 'elevation_total_height', '标高mm-全高', 3, 120, 0, 0, NULL),(77, 'cast_in_situ_structure', 'section_dimension_foundation', '截面尺寸mm-基础', 3, 130, 0, 0, NULL),(78, 'cast_in_situ_structure', 'section_dimension_cwsb', '截面尺寸mm-柱、梁、板、墙', 3, 140, 0, 0, NULL),(79, 'cast_in_situ_structure', 'section_dimension_stairs_step_height', '截面尺寸mm-楼梯相邻踏步高差', 3, 150, 0, 0, NULL),(80, 'cast_in_situ_structure', 'elevator_shaft_center_position', '电梯井mm-中心位置', 3, 160, 0, 0, NULL),(81, 'cast_in_situ_structure', 'elevator_shaft_dimensions', '电梯井mm-长、宽尺寸', 3, 170, 0, 0, NULL),(82, 'cast_in_situ_structure', 'surface_flatness', '表面平整度（mm）', 3, 230, 0, 0, NULL),(83, 'cast_in_situ_structure', 'embedded_part_bolt_position', '预埋件中心位置（mm）-预埋板', 3, 180, 0, 0, NULL),(84, 'cast_in_situ_structure', 'embedded_part_plate_position', '预埋件中心位置（mm）-预埋螺栓', 3, 190, 0, 0, NULL),(85, 'cast_in_situ_structure', 'embedded_part_pipe_position', '预埋件中心位置（mm）-预埋管', 3, 200, 0, 0, NULL),(86, 'cast_in_situ_structure', 'embedded_part_other_position', '预埋件中心位置（mm）-其他', 3, 210, 0, 0, NULL),(87, 'cast_in_situ_structure', 'reserved_opening_centerline_position', '预留洞、孔中心线位置mm', 3, 220, 0, 0, NULL),(88, 'concrete_construction', 'post_pour_strip_joint_method', '后浇带和施工缝的留设及处理方法', 2, 10, 0, 0, '共37处，全数检查，合格37处'),(89, 'concrete_construction', 'post_pour_curing_measures', '混凝土浇筑完毕后的养护措施', 1, 20, 1, 0, '洒水养护，符合施工技术方案要求')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`tasks` WRITE;
DELETE FROM `inspection_db`.`tasks`;
INSERT INTO `inspection_db`.`tasks` (`task_id`,`project_inner_number`,`project_id`,`subproject_name`,`task_type`,`task_location`,`task_deadline`,`task_starttime`,`task_state`,`inspect_items`,`task_volume`,`fail_resample`,`design_values`,`inspect_rule`) VALUES (101, NULL, 1, NULL, 'rebar_material', 'A区钢筋加工棚—HRB400 Φ20成型钢筋', '2025-08-18 18:00:00', '2025-08-15 09:00:00', '0', '[\"钢筋外观质量\", \"成型钢筋外观质量\"]', '5', 1, NULL, NULL),(102, NULL, 1, NULL, 'rebar_process', 'A区钢筋加工棚—箍筋加工', '2025-08-19 18:00:00', '2025-08-15 10:00:00', '1', NULL, NULL, 0, NULL, NULL),(103, NULL, 1, NULL, 'rebar_installation', '1-8/A-H轴二层梁板', '2025-08-21 18:00:00', '2025-08-16 09:00:00', '0', NULL, NULL, 1, NULL, NULL),(104, NULL, 2, NULL, 'formwork_installation', '2-5/A-D轴二层梁板模板', '2025-08-22 18:00:00', '2025-08-16 10:00:00', '0', NULL, NULL, 1, NULL, NULL),(105, NULL, 2, NULL, 'concrete_mix', 'A区2层泵送混凝土C30', '2025-08-17 18:00:00', '2025-08-16 13:00:00', '1', NULL, NULL, 0, NULL, NULL),(106, NULL, 1, NULL, 'concrete_construction', '1-8/A-H轴二层梁板浇筑', '2025-08-23 18:00:00', '2025-08-16 14:00:00', '0', NULL, NULL, 0, NULL, NULL),(107, NULL, 1, NULL, 'cast_in_situ_structure', '电梯井剪力墙—轴线定位与尺寸', '2025-08-16 18:00:00', '2025-08-15 15:00:00', '1', NULL, NULL, 0, NULL, NULL),(1001, 'P001', NULL, '主体结构', '_', '3F-钢筋加工区', NULL, NULL, '0', NULL, '[{\"info\": \"\", \"source\": \"钢筋\", \"volume\": 120}, {\"info\": \"补浇段\", \"source\": \"混凝土\", \"volume\": 30}]', NULL, '{\"tolerance\": {\"diameter_max\": 16.5, \"diameter_min\": 15.8}, \"rebar_spec\": \"HRB400 Φ16\", \"strength_grade\": \"C30\"}', 'GB50204-2015《混凝土结构工程施工质量验收规范》'),(1002, 'P002', NULL, '机电安装', '_', 'B1-设备间', NULL, NULL, '0', NULL, '[{\"info\": \"\", \"source\": \"电缆桥架\", \"volume\": 50}]', NULL, '{\"anti_rust\": \"环氧富锌底漆\", \"support_spacing\": 1500}', 'GB50300-2013《建筑工程施工质量验收统一标准》')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`user_project` WRITE;
DELETE FROM `inspection_db`.`user_project`;
INSERT INTO `inspection_db`.`user_project` (`user_id`,`project_id`,`project_role`) VALUES (1, 1, '项目管理员'),(1, 2, '数据采集员')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`user_task_inspection` WRITE;
DELETE FROM `inspection_db`.`user_task_inspection`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `inspection_db`.`users` WRITE;
DELETE FROM `inspection_db`.`users`;
INSERT INTO `inspection_db`.`users` (`id`,`user_code`,`username`,`user_password`,`role`,`company_name`,`external_pwd_hash`,`external_pwd_algo`,`last_sync_at`,`updated_at`) VALUES (1, '1', 'testuser', '14e1b600b1fd579f47433b88e8d85291', 'ADMIN', NULL, NULL, NULL, NULL, NULL),(2, 'U001', 'zhangsan', '14e1b600b1fd579f47433b88e8d85291', NULL, '???', NULL, NULL, '2025-09-10 14:17:31', '2025-09-10 14:17:31'),(3, 'U002', 'lisi', '14e1b600b1fd579f47433b88e8d85291', NULL, '???', NULL, NULL, '2025-09-10 14:17:31', '2025-09-10 14:17:31')
;
UNLOCK TABLES;
COMMIT;
